<#assign prefixName = 'WHERE'>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__beginDate??)>
	<#if (where__and__eq__beginDate__value??)>
${prefixName} T.BEGIN_DATE = :where__and__eq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__and__nq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__and__like__beginDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__beginDate__value??)>
${prefixName} T.BEGIN_DATE = :where__or__eq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__or__nq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__or__like__beginDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__endDate??)>
	<#if (where__and__eq__endDate__value??)>
${prefixName} T.END_DATE = :where__and__eq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__endDate__value??)>
${prefixName} T.END_DATE <> :where__and__nq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__endDate__value??)>
${prefixName} T.END_DATE <> :where__and__like__endDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__endDate__value??)>
${prefixName} T.END_DATE = :where__or__eq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__endDate__value??)>
${prefixName} T.END_DATE <> :where__or__nq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__endDate__value??)>
${prefixName} T.END_DATE <> :where__or__like__endDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__between__sysdate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'AND'>
</#if>
${prefixName} SYSDATE BETWEEN T.BEGIN_DATE AND T.END_DATE
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__entityCode??)>
	<#if (where__and__eq__entityCode__value??)>
${prefixName} T.ENTITY_CODE = :where__and__eq__entityCode__value
	<#else>
${prefixName} T.ENTITY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__entityCode__value??)>
${prefixName} T.ENTITY_CODE <> :where__and__nq__entityCode__value
	<#else>
${prefixName} T.ENTITY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__entityCode__value??)>
${prefixName} T.ENTITY_CODE <> :where__and__like__entityCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__entityCode__value??)>
${prefixName} T.ENTITY_CODE = :where__or__eq__entityCode__value
	<#else>
${prefixName} T.ENTITY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__entityCode__value??)>
${prefixName} T.ENTITY_CODE <> :where__or__nq__entityCode__value
	<#else>
${prefixName} T.ENTITY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__entityCode__value??)>
${prefixName} T.ENTITY_CODE <> :where__or__like__entityCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__entityId??)>
	<#if (where__and__eq__entityId__value??)>
${prefixName} T.ENTITY_ID = :where__and__eq__entityId__value
	<#else>
${prefixName} T.ENTITY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__entityId__value??)>
${prefixName} T.ENTITY_ID <> :where__and__nq__entityId__value
	<#else>
${prefixName} T.ENTITY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__entityId__value??)>
${prefixName} T.ENTITY_ID <> :where__and__like__entityId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__entityId__value??)>
${prefixName} T.ENTITY_ID = :where__or__eq__entityId__value
	<#else>
${prefixName} T.ENTITY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__entityId__value??)>
${prefixName} T.ENTITY_ID <> :where__or__nq__entityId__value
	<#else>
${prefixName} T.ENTITY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__entityId__value??)>
${prefixName} T.ENTITY_ID <> :where__or__like__entityId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__entityName??)>
	<#if (where__and__eq__entityName__value??)>
${prefixName} T.ENTITY_NAME = :where__and__eq__entityName__value
	<#else>
${prefixName} T.ENTITY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__entityName__value??)>
${prefixName} T.ENTITY_NAME <> :where__and__nq__entityName__value
	<#else>
${prefixName} T.ENTITY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__entityName__value??)>
${prefixName} T.ENTITY_NAME <> :where__and__like__entityName__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__entityName__value??)>
${prefixName} T.ENTITY_NAME = :where__or__eq__entityName__value
	<#else>
${prefixName} T.ENTITY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__entityName__value??)>
${prefixName} T.ENTITY_NAME <> :where__or__nq__entityName__value
	<#else>
${prefixName} T.ENTITY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__entityName__value??)>
${prefixName} T.ENTITY_NAME <> :where__or__like__entityName__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__entityParentCode??)>
	<#if (where__and__eq__entityParentCode__value??)>
${prefixName} T.ENTITY_PARENT_CODE = :where__and__eq__entityParentCode__value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__entityParentCode__value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where__and__nq__entityParentCode__value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__entityParentCode__value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where__and__like__entityParentCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__entityParentCode__value??)>
${prefixName} T.ENTITY_PARENT_CODE = :where__or__eq__entityParentCode__value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__entityParentCode__value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where__or__nq__entityParentCode__value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__entityParentCode__value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where__or__like__entityParentCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__entityParentId??)>
	<#if (where__and__eq__entityParentId__value??)>
${prefixName} T.ENTITY_PARENT_ID = :where__and__eq__entityParentId__value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__entityParentId__value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where__and__nq__entityParentId__value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__entityParentId__value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where__and__like__entityParentId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__entityParentId__value??)>
${prefixName} T.ENTITY_PARENT_ID = :where__or__eq__entityParentId__value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__entityParentId__value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where__or__nq__entityParentId__value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__entityParentId__value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where__or__like__entityParentId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__entityParentName??)>
	<#if (where__and__eq__entityParentName__value??)>
${prefixName} T.ENTITY_PARENT_NAME = :where__and__eq__entityParentName__value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__entityParentName__value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where__and__nq__entityParentName__value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__entityParentName__value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where__and__like__entityParentName__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__entityParentName__value??)>
${prefixName} T.ENTITY_PARENT_NAME = :where__or__eq__entityParentName__value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__entityParentName__value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where__or__nq__entityParentName__value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__entityParentName__value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where__or__like__entityParentName__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__id??)>
	<#if (where__and__eq__id__value??)>
${prefixName} T.ID = :where__and__eq__id__value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__id__value??)>
${prefixName} T.ID <> :where__and__nq__id__value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__id__value??)>
${prefixName} T.ID <> :where__and__like__id__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__id__value??)>
${prefixName} T.ID = :where__or__eq__id__value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__id__value??)>
${prefixName} T.ID <> :where__or__nq__id__value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__id__value??)>
${prefixName} T.ID <> :where__or__like__id__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__treeCode??)>
	<#if (where__and__eq__treeCode__value??)>
${prefixName} T.TREE_CODE = :where__and__eq__treeCode__value
	<#else>
${prefixName} T.TREE_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__treeCode__value??)>
${prefixName} T.TREE_CODE <> :where__and__nq__treeCode__value
	<#else>
${prefixName} T.TREE_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__treeCode__value??)>
${prefixName} T.TREE_CODE <> :where__and__like__treeCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__treeCode__value??)>
${prefixName} T.TREE_CODE = :where__or__eq__treeCode__value
	<#else>
${prefixName} T.TREE_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__treeCode__value??)>
${prefixName} T.TREE_CODE <> :where__or__nq__treeCode__value
	<#else>
${prefixName} T.TREE_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__treeCode__value??)>
${prefixName} T.TREE_CODE <> :where__or__like__treeCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__treeId??)>
	<#if (where__and__eq__treeId__value??)>
${prefixName} T.TREE_ID = :where__and__eq__treeId__value
	<#else>
${prefixName} T.TREE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__treeId__value??)>
${prefixName} T.TREE_ID <> :where__and__nq__treeId__value
	<#else>
${prefixName} T.TREE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__treeId__value??)>
${prefixName} T.TREE_ID <> :where__and__like__treeId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__treeId__value??)>
${prefixName} T.TREE_ID = :where__or__eq__treeId__value
	<#else>
${prefixName} T.TREE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__treeId__value??)>
${prefixName} T.TREE_ID <> :where__or__nq__treeId__value
	<#else>
${prefixName} T.TREE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__treeId__value??)>
${prefixName} T.TREE_ID <> :where__or__like__treeId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__treeName??)>
	<#if (where__and__eq__treeName__value??)>
${prefixName} T.TREE_NAME = :where__and__eq__treeName__value
	<#else>
${prefixName} T.TREE_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__treeName__value??)>
${prefixName} T.TREE_NAME <> :where__and__nq__treeName__value
	<#else>
${prefixName} T.TREE_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__treeName__value??)>
${prefixName} T.TREE_NAME <> :where__and__like__treeName__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__treeName__value??)>
${prefixName} T.TREE_NAME = :where__or__eq__treeName__value
	<#else>
${prefixName} T.TREE_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__treeName__value??)>
${prefixName} T.TREE_NAME <> :where__or__nq__treeName__value
	<#else>
${prefixName} T.TREE_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__treeName__value??)>
${prefixName} T.TREE_NAME <> :where__or__like__treeName__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__typeId??)>
	<#if (where__and__eq__typeId__value??)>
${prefixName} T.TYPE_ID = :where__and__eq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__and__nq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__and__like__typeId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__typeId__value??)>
${prefixName} T.TYPE_ID = :where__or__eq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__or__nq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__or__like__typeId__value
	</#if>
	<#assign prefixName = ''>
</#if>
